﻿CREATE TABLE [dbo].[Specializations]
(
	[ID] INT IDENTITY (1, 1) NOT NULL,
	[Name] VARCHAR (100) NOT NULL,
	[DepartmentID] int NOT NULL
)
Go
ALTER TABLE [dbo].[Specializations]
    ADD CONSTRAINT [PK_Specializations] PRIMARY KEY CLUSTERED ([ID] ASC)

GO
